SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68800 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68800 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17206,1023322,256393,624389,555163,259761,175659,742823,176841,524946,1024657,356184,135262,311720,103764,491035,394071,677892,209204,794053,295715,331147,1002999,705217,142860,826257,868460,272120,633737,664666,726918,14108,313692,674499,607949,638345,659526,231410,575187,10380,776822,106045,377646,647571,647115,238025,585874,149355,1015304,6902,2857,478203,545941,700645,1019720,80857,574589,528279,224052,432090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]