SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520566 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520566 [ RunTime:0.002542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460713,573605,49360,864277,1016901,185337,686584,204065,670812,42662,144729,157139,442854,966792,955353,355783,618807,1012711,885358,1014453,961568,677067,1024780,619952,192976,331199,495822,107902,792039,444525,107676,636382,858854,790207,931287,121616,913242,745479,629069,495339,192644,400199,420794,1045677,858665,448129,472168,646212,173870,844471,706921,747837,695131,974028,501629,513307,996605,581921,370330,170042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]