SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971180 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971180 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831640,802320,454059,312608,800661,460832,864845,149174,282625,319977,538995,60081,1041291,332313,27950,117546,990642,626736,16141,27389,839708,36430,649869,876424,527383,129360,908403,474391,982276,196119,577643,966190,185250,523422,327641,612055,742358,174208,615349,129705,287911,97356,957650,370546,654620,111035,169511,367454,310427,638544,580287,143910,952230,476638,860664,873415,522776,443482,152766,861325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]