SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041020 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041020 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197261,531142,809789,503182,84478,605528,1018673,155235,1004045,433460,561970,257425,783020,940139,248648,62925,515725,83932,917992,668033,173157,822790,158390,814335,749958,311793,988428,657026,86608,711838,1000300,598457,972466,443759,136500,897470,111962,672470,911922,600098,38606,417786,790151,392239,458868,419462,81551,461001,324494,716699,317737,911685,515619,683498,69225,210711,567185,943546,591734,433691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]