SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412974 LIMIT 1 [ RunTime:0.001171s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412974 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404133,675495,627208,1011649,173282,236016,696672,245522,463718,292789,888662,527497,568298,934757,405863,367261,423102,871019,691258,908573,506473,607103,61561,372577,715803,657675,983817,669665,85914,505578,513100,914474,258043,145309,1021541,666027,69123,200371,177765,130741,1039100,50,945584,257294,420921,674747,735740,236457,540793,787291,520135,385218,832734,432876,91920,754111,977571,780068,729268,219027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]