SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285401 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285401 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432181,951972,638329,829447,431447,963095,734026,734041,1027055,532419,956828,405284,572599,758462,561847,313194,914872,487704,10066,935950,220356,630156,37414,853320,505213,334860,804317,436451,387355,565763,897382,736096,166869,979776,382163,919003,89381,486727,661368,104403,686611,305850,942407,470358,412954,1040187,259665,282558,452972,861202,734803,863157,143996,888309,11293,347209,712696,151835,45882,466831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]