SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409208 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409208 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497761,79776,769656,1017347,455802,844617,381278,268684,146026,415115,813346,496165,972182,748461,163473,990976,761088,506208,319986,73527,555113,716713,335788,921149,756690,936548,574679,939640,92990,625945,867613,666829,1046634,109948,631830,653297,335607,239317,646808,187875,226980,1046695,186216,874523,735020,170359,329131,133050,603837,587228,1011172,1024999,936290,169818,546007,382089,489763,508038,237105,811644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]