SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511384 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511384 [ RunTime:0.005221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197259,183581,704950,179536,72785,995230,937912,911674,75510,147999,591100,549866,913768,487276,160665,728984,37170,604966,315313,838088,153032,425277,226355,701242,814409,142673,14543,374260,360302,673444,484062,729369,43348,197231,255417,546918,1001096,516634,276804,762613,895237,490757,860441,303423,182012,12206,465474,172200,677414,298751,95665,1005851,372128,34119,584078,194934,60523,346950,404344,928254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]