SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971094 LIMIT 1 [ RunTime:0.000655s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971094 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390236,4205,682473,440569,266511,894888,672619,706429,537500,93822,725110,32734,620181,960035,979623,767972,820586,909992,53377,669658,986707,726574,718030,798992,839267,617037,96618,922036,769673,54297,914423,263305,841975,332628,881024,85464,459212,249221,473826,802588,698423,408234,979961,339967,1022396,184780,847024,534734,878283,511356,573096,438614,480180,40200,387334,240588,890583,502230,749664,984090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]