SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145034 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145034 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177270,210912,10922,953840,100750,746038,930385,958402,864673,39619,109542,5748,481325,459492,684475,385910,484201,804462,712100,130943,1036401,814982,950310,983820,900950,66752,746877,183481,344244,418555,154098,743899,287852,871293,676099,444159,643019,957593,1046063,925163,966973,82282,772756,21162,222791,352554,136994,714378,842681,177579,180247,472014,309052,1034028,412836,624469,516345,705221,254228,578794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]