SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400516 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400516 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232534,700486,985713,272753,489619,342747,315058,181106,506058,266735,94568,985696,933905,730653,1001313,927969,431143,44637,738722,1009485,645178,206710,294732,74582,749814,362458,422817,860105,400193,262096,21028,388485,1019769,605939,831038,613110,638718,939858,630645,156534,926530,1034304,406215,694647,595513,408452,980529,430620,307810,53233,277924,657991,60670,289956,267259,537854,662268,134684,617361,977948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]