SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003574s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031258 LIMIT 1 [ RunTime:0.004346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031258 [ RunTime:0.002285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499902,486690,912026,547762,354312,349209,848590,54310,236297,898904,378854,664235,350811,686038,652326,992481,1006132,523429,469339,14813,723723,749558,342120,434628,982507,954509,254487,201114,826494,570912,1030117,43397,952591,932612,318053,151533,880886,440635,532227,721073,685222,459224,202875,780537,877173,57505,991848,349305,326136,971648,245576,107795,851860,827560,408047,385334,640285,435308,254085,530573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002572s ]