SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84160 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84160 [ RunTime:0.002959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3652,93917,356403,497150,341621,332940,116600,311851,872275,1039153,480432,126629,611889,207087,223442,95306,674783,965049,548720,288773,591393,84925,544008,869030,190075,255942,1006564,670935,859057,606409,786998,235571,292840,177477,603724,624390,634948,786331,560329,971967,392262,265032,482191,582364,912260,791163,799329,127102,206938,898264,118120,857310,262991,795408,303906,1007759,508190,319682,787771,76810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000950s ]