SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519805 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519805 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120228,292057,449038,376290,983714,110228,212275,847390,647941,688965,434061,666101,996768,536891,346498,501342,206522,364324,287289,66222,1045540,643618,391663,11459,732265,916881,271001,263535,486249,839348,115478,9586,1023439,877156,453417,1017013,431884,256084,21335,284827,903732,654748,67923,106362,86940,890897,974731,432057,631344,275541,352110,791733,868616,1035404,993647,1030053,333284,972257,300884,396388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]