SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409220 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409220 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444076,28798,282947,478941,351465,860965,162052,730811,757546,984735,298377,118112,336683,797463,396296,287302,931268,347647,907916,48869,808609,63141,217118,458969,703443,365615,134130,913884,721722,852070,798988,179572,900233,36465,113962,693922,1008629,599920,318815,807793,625100,445748,87445,385376,933056,549833,840217,1026205,327952,1040246,723267,545475,26180,11368,925161,56112,699427,359381,619701,114852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]