SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502916 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502916 [ RunTime:0.002282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677662,655826,38838,1034853,876318,444432,568368,578414,774760,322013,646173,342458,124894,377925,40571,656189,521910,764913,911899,179682,474298,963038,895626,1037245,837473,652257,788386,30963,807422,266481,353375,210308,778572,69836,611106,392533,494998,801378,442390,782736,805986,141309,121640,847790,476559,620748,832766,723772,841844,357197,168820,392450,247437,335542,164775,575437,814346,205103,403152,304576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]