SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509518 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509518 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198232,760729,391285,627165,143453,211562,671136,599218,1035971,156232,67399,753102,855555,122066,409215,129929,828261,413067,400693,368950,128745,77114,724869,568505,90746,108828,844823,827335,615482,488308,365713,428885,500410,289334,614585,661616,297100,479214,14670,422811,152587,827710,421839,161642,139214,274620,63927,425268,890243,621703,552110,753405,224159,51307,918737,806556,370751,722524,444430,271403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]