SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475648 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475648 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467774,532490,267765,631530,738494,129109,989599,391654,626984,117379,736959,216948,14107,836276,651861,60863,615063,230214,196813,435118,1037267,881638,399558,580585,752998,895185,586139,623401,55680,914561,774814,420751,340138,540203,440898,660012,133556,366052,1003347,207947,111140,327381,332141,844735,481427,217215,398496,768317,480933,446247,263467,20317,474087,959140,64539,964209,571823,100004,833701,743680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]