SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254626 LIMIT 1 [ RunTime:0.003085s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254626 [ RunTime:0.001237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41812,287113,197502,979803,922876,513208,251059,611481,804177,78479,850313,990422,195538,77417,1027711,202677,901942,239327,994724,899,721089,351635,533913,500108,320289,1044176,860506,373614,969365,204596,924261,960252,478742,420245,1013863,1037460,899418,113436,43804,800027,747953,678472,510533,794731,382211,235783,641777,1023690,331545,55423,754446,1032699,957888,572391,982221,742261,449076,939224,412214,145534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]