SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559615 LIMIT 1 [ RunTime:0.001266s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559615 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959201,612428,625043,197202,729193,411819,217795,716361,142724,707357,913995,267422,1010172,168500,453053,839670,136976,1046471,48342,746585,427743,472661,150392,464887,467730,656363,935897,854143,415206,505485,684499,477070,408282,299400,716736,450032,669871,355871,132245,272874,821860,863340,505701,294215,476189,331045,220572,775471,82799,957916,578725,880994,253235,315925,167451,896898,170339,926627,634307,1011841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]