SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192601 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192601 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411585,283206,796512,960730,410270,686179,1041998,11498,696225,559292,87954,733025,713917,667877,391385,770464,908879,729634,1042582,383696,274734,479262,12455,615712,504704,187134,131833,407851,1002242,550265,686948,173808,330096,679658,779795,634153,762071,864039,745206,225062,935731,816858,140840,551227,656773,764114,500462,847796,1035039,789356,838871,540837,216500,471836,295276,822428,521379,582626,771801,227008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000373s ]