SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445599 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445599 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628138,642399,6310,767638,197769,625337,40198,955737,712350,399621,221557,166964,116677,525513,226054,313383,491633,439099,485946,715817,589730,872712,660690,959204,627133,991539,56727,460827,363908,737866,747602,118950,837967,905829,795373,407548,578748,139837,935817,960666,131267,344146,400241,352093,339318,245679,452757,656452,825728,20186,997620,623059,321503,82549,489729,217486,361094,732834,820112,1048688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]