SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543817 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543817 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396586,31765,224885,970550,976446,486095,385474,429361,230786,204834,1024249,615720,67292,662231,530122,587654,611902,563519,373382,561764,537008,797146,695464,846489,858172,694426,370553,516202,944203,277118,241415,342072,66134,409000,203529,645235,250645,353002,911572,745174,393163,368867,759283,271066,928657,996294,162169,340475,292226,95326,777841,1876,801771,764774,541166,318007,135904,434253,7136,262337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000812s ]