SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022213 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022213 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524929,203235,397021,36027,960154,145894,27760,400002,827049,638948,867017,877164,572108,127830,809082,761895,615920,938521,539882,863150,361427,1026125,840535,412076,429787,573605,875848,490941,29506,98702,666668,1043650,989560,410716,578342,361920,835926,754291,979188,310356,863006,552965,950742,722355,984185,731291,700225,321667,1028668,916226,158855,506893,265850,288581,307276,221857,571378,277402,589491,249731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]