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` = 410683 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410683 [ RunTime:0.003287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832940,400469,405054,753844,766272,241496,531054,709324,640841,485137,1000770,356096,931680,484755,991443,666685,106659,249043,626047,380580,997641,43836,615789,860638,449140,796117,685099,743534,993684,96977,400571,386120,457319,223515,240603,153161,151791,786288,330800,298980,257382,513249,944368,909923,473874,661064,241924,227133,777730,175383,816931,281246,228398,480763,901839,764418,943873,925743,1046687,50774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]