SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265022 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265022 [ RunTime:0.004181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401029,184473,845753,520882,582138,671238,580802,521644,164061,369017,346678,812044,155823,750083,420220,967235,879002,900460,881854,487282,607397,144243,110047,485492,769997,506425,345323,701917,396322,736349,869949,807930,827631,242746,394808,192017,722203,407320,53395,392989,671984,146478,77774,181841,669827,840489,277209,189262,237841,919251,269304,232755,922541,24022,374165,113699,447414,687774,753294,4653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]