SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 965083 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 965083 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141801,326038,335644,916524,155465,446836,537867,506639,931117,844919,258172,536079,97207,73900,920186,336032,834724,815681,581293,448476,428037,257638,988771,575003,837758,958358,44313,40170,31768,309421,573397,581623,661207,161214,277112,120561,709961,6449,509760,45702,399669,162757,145760,595347,925837,899751,427347,731963,803436,866470,368448,852792,1014345,485424,480880,445692,105377,277404,385509,896455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 965083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 965083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]