SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29588 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29588 [ RunTime:0.006183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690766,728683,139637,409945,466658,642488,641844,450010,648628,975654,381011,905472,597885,468463,1010330,541310,909556,899393,433180,315014,361920,235246,694330,812670,518960,189543,511590,216640,930073,10127,468415,916175,414698,764074,762520,844007,477862,534942,1031902,940997,384001,650358,490323,859646,310176,838636,535085,384227,268020,643175,155309,489948,108154,734369,396479,124622,933319,270797,30198,341889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]