SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005180 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005180 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633440,855591,309671,374743,544389,701244,501420,111888,88812,745236,260468,512545,816188,530319,210462,27371,730005,610650,909825,609235,268273,622827,795195,146654,609753,308434,489910,359994,750051,826362,547184,150431,585453,383708,205435,1010638,428849,700729,637761,928835,1014096,878630,658856,827687,579348,969332,1033450,520579,976606,592854,453514,983145,991521,86693,872959,492237,689309,891360,914967,416796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]