SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146984 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146984 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309071,144957,713649,78928,21835,713623,55373,297141,497506,709691,692959,825014,847958,44780,982439,618802,501150,996317,694006,204376,739693,566190,30437,50687,180961,207738,910491,270936,85926,280750,447724,887627,199845,1007844,746827,584651,304281,917926,732885,630267,550331,408030,285831,685559,659340,781757,635485,738646,858408,184188,538979,562764,518351,839978,68001,130346,197991,531490,14372,729308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]