SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505551 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505551 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198163,158326,233871,718308,494899,402534,684298,615503,693296,125362,398851,884068,402033,183618,172658,75400,781540,775543,231536,33038,44539,368478,873560,884670,768149,41065,506273,741746,703320,93974,740860,863330,904017,981682,108245,753204,10210,741673,30368,757751,757371,48672,1036770,340099,750182,121835,356594,123826,475942,550377,347227,109747,875834,308309,412584,962549,295919,638709,332048,505555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]