SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437036 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437036 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15358,618221,648030,488454,711033,228778,109678,181990,124268,916554,985137,464102,548288,99929,551750,609752,975340,728012,4673,776680,533808,225352,860538,172075,963569,80912,857206,344313,700192,733699,1040935,185798,644290,984973,969428,232641,933677,111537,863549,691202,198967,445365,566910,707525,275020,479409,52587,653021,106589,264350,595756,819442,1044051,1037067,600340,554110,708393,584515,164768,466550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003753s ]