SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454568 LIMIT 1 [ RunTime:0.001269s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454568 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393741,801285,423485,321698,193811,506621,45496,548238,406207,1005046,260763,916654,88738,983348,706572,607698,636229,514069,671355,128549,937109,618860,616110,771859,94159,49671,296329,435088,548054,552518,374350,218674,558512,424544,829596,11417,489215,50663,731555,78749,173827,825997,802215,838756,144570,168240,433767,525713,253631,500392,255132,71334,333116,205199,398452,511830,348896,393508,540411,5220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001279s ]