SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464863 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464863 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546716,809497,992704,140683,571310,25529,599670,210863,169031,822780,138513,170218,586113,57118,123617,975770,147093,1027996,315799,992910,117592,553385,867109,790858,590964,290963,174028,764881,866929,1014545,254553,954128,774040,346359,809336,216399,811147,102024,518098,709870,45834,252392,72592,766691,855109,296669,238209,656596,1015190,735468,741011,33113,981326,562013,388729,189324,421481,248623,634992,640743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]