SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002876s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408698 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408698 [ RunTime:0.001428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340712,409534,996382,157007,860393,916193,189658,157590,617837,967702,188088,422410,184060,660426,552493,247466,589371,155418,690785,70879,884999,450247,364197,533844,7068,241250,1000444,595932,932391,139442,108939,96086,441114,1512,211772,278652,623468,575068,1012975,258585,18910,422710,441204,569077,808320,671037,641336,263994,384586,375738,805145,645463,372601,497328,109859,561124,953633,60477,854727,184607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]