SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681754 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681754 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818192,651267,835266,970918,126902,953016,731335,619254,1045986,869545,386374,25167,752167,727358,921519,1017577,819892,243752,217806,849946,178817,863582,818380,656900,975198,417594,577512,323630,403215,142998,1007815,497605,588190,829918,706047,1017886,1047732,306634,432457,457667,142432,41365,15775,418110,116425,530257,585669,398220,628384,342202,593337,267971,944615,840239,119936,367594,37622,967359,551872,554052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]