SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033707 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033707 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475860,316949,445851,754378,211761,1000398,425841,767704,377385,452537,1000407,768184,711488,58100,328373,578143,189357,466626,245083,160593,4747,159541,507974,691826,900547,829684,535442,225565,711340,545435,110275,457205,130282,295645,429645,601718,872409,369690,665060,772427,887379,821487,22085,725525,50273,85798,268745,610192,658280,39081,867657,559717,520181,554105,970816,469764,279572,873340,312129,396395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]