SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403802 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403802 [ RunTime:0.003432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679418,566202,977837,971529,257017,450014,722213,54541,210938,724494,672027,600261,320974,357685,702892,262379,898437,922701,1004537,267551,905347,885541,814035,594984,201007,140276,890512,438945,905221,95329,30760,579046,718279,683452,993830,481970,947603,1046934,144069,454694,790701,293963,673392,576578,366529,14643,802441,198687,181728,505452,416959,346599,525565,1025233,948725,54818,615674,195391,94807,166308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]