SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520571 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520571 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173259,170223,91342,833549,203768,521777,763864,523157,793525,804712,1013475,768086,965824,578932,688326,171154,521899,283814,174080,610798,35691,522805,605489,102733,410702,303804,440302,366474,774410,205166,158065,81819,16586,595566,975289,250034,23035,798736,922338,1009995,494762,221514,317996,626620,558882,246007,631607,443295,527324,516541,42463,479099,101857,761012,771982,477055,806829,122865,507977,179691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]