SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012303 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012303 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848705,229253,244091,348924,506981,302544,959465,318010,535203,258439,395809,665908,548623,27761,759680,856204,1042896,542783,85937,928153,642655,460991,60453,21214,734180,809695,862453,749170,585794,54037,508063,797770,395069,175574,858230,234782,213556,182557,135228,898463,289303,900557,57059,300136,368292,951146,205598,378264,798690,539060,575260,258821,999127,302802,600957,79,191175,20624,351844,855317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]