SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504049 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504049 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923074,222779,156450,168646,12935,231702,424130,1011013,85804,976613,169629,313330,453867,317287,628014,38155,877597,628189,652362,260029,294402,669104,1023963,289060,130612,524999,1033364,471547,226097,741349,69444,735669,744138,245893,664580,378527,704693,602530,354723,448535,581874,788876,545962,589249,139779,974864,131961,294979,88566,381731,1022186,356534,463939,31604,760591,236193,254754,757109,1039671,436715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]