SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498399 LIMIT 1 [ RunTime:0.003861s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498399 [ RunTime:0.002926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341466,731634,974240,940208,915554,705752,11349,318332,308298,626845,188648,891983,1021114,577193,115593,597282,968471,144810,379277,35443,313130,401468,318891,690185,667776,938088,708467,610873,754409,273702,916508,641095,852445,1039516,294554,135661,83072,735386,1024328,641698,449757,367419,296835,277971,842757,290436,689076,785636,886756,963545,829559,1034681,229701,240092,69329,915013,464737,229069,361620,421625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]