SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432701 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432701 [ RunTime:0.002406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136722,241057,652539,1016626,473574,88490,778845,333579,755210,160831,210259,1002684,1043229,493290,546720,78754,947151,1033237,744137,963537,1005707,447742,491589,906031,964568,359371,830787,213602,509006,346108,571108,282407,912494,468524,972761,705762,623702,109614,31723,900030,226132,305215,606230,1024931,786439,1018792,156631,108152,379558,769802,981818,123330,456870,1038009,780887,79018,302023,821207,960094,786941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]