SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449681 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449681 [ RunTime:0.002441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83849,508235,365848,298795,702803,609073,923649,326919,176743,423796,375855,524092,538108,85118,411230,551943,922706,842160,679822,472229,39779,723203,1019095,933964,483844,1042425,943512,762466,609150,575075,464948,112547,42831,801093,773905,717307,39978,346478,349831,674612,10098,558170,771080,9929,399153,240273,334182,479778,133859,164646,235677,202945,869456,239853,538111,181318,214056,475645,687281,120162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]