SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013118 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013118 [ RunTime:0.002410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335630,723367,932473,466805,909267,77065,24926,831997,315446,442402,183058,732344,398623,456675,643680,723833,134992,410053,478078,725110,53242,303423,552654,280045,713187,636044,660545,49445,231630,538660,787691,569298,886754,87955,550448,89450,29235,690490,631970,462662,910827,679773,650501,221076,861759,186345,451204,279519,519743,476795,850332,100450,951365,213526,977342,769310,472646,788089,700748,676766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002035s ]