SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44136 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44136 [ RunTime:0.002670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296334,698394,408286,658644,860227,946561,800467,360917,1042639,133429,568099,680062,142553,2985,866126,987565,469169,247895,148440,7996,275151,442150,334978,475817,596325,489843,774483,645485,576321,475261,481799,742474,515639,324630,177078,1012344,616210,310945,671774,483640,998794,68120,206641,649267,135066,614034,601272,951484,984839,167366,590874,339211,110722,619174,985303,369116,297939,629498,278045,157917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]