SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003522 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003522 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126578,138754,473200,233484,541691,387932,400037,443640,321480,21092,115136,968549,599205,693117,275710,691871,346802,196590,977665,1008232,961865,762895,748024,404820,640740,715961,188222,975470,449211,525273,455758,80626,391251,996776,465282,182706,697136,728962,793325,158363,83437,298914,112148,758792,409998,892941,160282,408707,735304,1043149,637264,184798,895678,732406,177778,767462,228379,337587,964857,893075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]