SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196512 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196512 [ RunTime:0.002729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046163,1015114,349771,1004055,568787,264307,735202,1039137,263646,48072,187901,324198,724216,323406,923539,533568,650228,303648,562794,925550,77851,218934,244222,893793,198139,91469,548307,792420,83425,627226,1023465,840467,365943,490671,115682,396154,170455,541025,434277,189193,33720,916451,220808,105326,121607,421028,767213,1031317,197203,692442,789250,35033,276583,831829,875779,789813,163113,940350,710821,629906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]