SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 935103 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 935103 [ RunTime:0.003028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037816,891741,866798,601970,446598,668806,666267,975246,213472,60231,262775,667649,173681,194363,762274,817975,131183,291156,850470,304490,938169,904044,136028,504276,64795,673366,278181,682709,481292,401959,696195,349294,569054,135111,52685,29101,119796,637696,763779,1013889,498557,690534,581680,687583,3442,200722,110456,414958,580686,225504,452322,596364,127483,1034756,66623,42310,890699,865332,502815,793554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 935103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 935103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000862s ]