SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491127 LIMIT 1 [ RunTime:0.001410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491127 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128909,507457,721365,804897,14675,993639,618461,681806,1003313,200412,850365,693203,302011,1010424,13738,913801,428826,116430,771334,513103,1014592,271371,933055,846671,523101,359354,950947,25539,622475,98559,7027,134123,1029795,699641,990178,982476,424688,773116,873942,17886,789207,234878,615782,71807,748680,409164,579779,735681,172274,401211,402702,590459,774488,1031719,535270,960065,239042,573731,574299,990786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491127 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491127 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]