SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460954 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460954 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203985,971142,865549,343352,968748,925585,91220,591922,748895,453113,562353,247650,121053,734700,638806,844216,443248,945825,647874,455566,1003551,283287,354473,730538,447669,81158,133123,106701,800314,815712,453550,97175,356705,665622,444377,132297,513527,961899,522682,523897,874290,194091,401229,861485,25035,95545,950438,834721,1009107,816204,211733,762623,787712,819031,215899,281521,108594,706242,8856,935060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]