SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415893 LIMIT 1 [ RunTime:0.001315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415893 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736799,887836,891281,884559,218777,1004908,926821,481638,964551,484057,914342,866758,608497,668840,193561,651489,779975,304693,952617,1013077,123917,376309,1037199,759141,389526,234596,718624,445199,305642,602396,949288,901558,843059,742789,688902,521036,295076,785352,148827,662351,64622,408821,685235,493265,408388,20749,468767,36278,552237,785701,960189,36503,66972,826090,359798,568296,122934,333990,210812,288978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002975s ]