SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418641 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418641 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555853,635137,460466,1009142,993512,322877,18019,837288,41897,545717,192867,128782,1042954,829566,524414,646698,90117,874790,139259,410699,365710,145844,968251,492423,684179,378598,48295,939758,757930,134918,792361,771269,103141,626512,5630,821023,332886,66428,431740,785120,479392,855613,83855,873457,376697,113242,271965,964288,736536,158595,644862,856676,485712,214240,766370,279634,296866,983786,636880,148040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]