SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440984 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440984 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573270,203384,48778,178889,216250,555673,597352,447447,648921,372278,329073,285796,789108,451150,202368,512724,639512,840900,233783,147682,303806,516412,1041232,19201,343495,673675,102798,575447,151765,32434,345558,447184,617667,363369,760220,983703,314455,764617,770425,187643,990765,326858,806837,749891,812207,1003180,76782,627675,348548,601828,801317,318441,328158,393737,181154,47504,247940,179364,482092,901951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]