SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100240 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100240 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366074,836520,701471,156123,442853,664761,23930,616571,414574,289601,35466,962931,233320,614389,710536,722690,965841,61275,121546,582759,527433,992026,449283,468333,572227,940352,685655,302897,481517,928211,499583,505384,885247,178695,114988,508803,734460,518447,533282,94558,977829,294150,266425,828886,512033,321792,467021,668498,440524,617572,225582,245306,166364,153086,634119,212750,1008114,195182,513624,804800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000959s ]