SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106035 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106035 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868628,98451,793802,699202,354927,766226,289402,480990,728816,291529,782794,746351,61745,631275,1000000,892997,667963,666026,917665,969005,143223,578080,333134,384884,23645,374815,765736,277739,958216,554299,206200,58901,820462,1020124,571578,575911,541980,454102,942370,86029,654850,997410,406817,754553,465013,916991,122776,991532,376099,371373,1042228,1015993,877678,85005,734980,612306,577753,389125,354413,310578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004500s ]