SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020973 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020973 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32585,529071,732410,935803,174189,91905,13507,506909,24388,43188,3886,872353,448862,611904,988954,178466,747882,959742,915538,351498,5892,684001,568732,122276,490865,854597,910630,968916,213856,698626,316614,250343,742579,822967,1010767,296482,599178,347101,630951,225001,510187,637498,385725,797682,721083,292449,774774,170434,296620,868549,265826,799459,374623,459957,273872,11458,60262,210557,382054,547489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]