SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047470 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047470 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386593,794431,750922,884338,656676,526601,866299,692213,451076,650380,517134,858075,751819,664881,81764,834934,1044314,252919,286791,829931,179619,529312,708357,539666,903122,332299,564358,450555,565094,233071,742805,406018,413049,986519,516818,686970,1014909,388650,624699,879261,30825,1021641,443738,510207,226856,1702,152390,475147,646168,201437,929225,793198,589974,662299,127275,816710,177836,562465,83939,86620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]