SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532121 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532121 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615972,333632,246435,132529,47341,739433,495237,189854,1029881,341661,198634,880519,130422,1015239,778720,1029596,927122,296360,1020148,422356,1046856,25320,76550,931725,680361,473162,712300,493825,555500,641017,680325,132185,321915,444652,1045519,583452,261939,161794,480486,221765,163615,346262,193628,89434,147729,423703,348313,368171,125849,343618,408069,334941,456139,92611,120750,825811,887318,460029,236876,496637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]