SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002715s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473985 LIMIT 1 [ RunTime:0.001419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473985 [ RunTime:0.002788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258081,250868,35419,352966,839969,436850,834710,811117,1025772,981750,450009,810370,956322,128048,161157,948626,418400,84777,52027,285088,65071,180145,823652,141097,555023,516096,840702,772838,459964,9401,742588,810084,816905,807368,871467,109099,1013135,452496,958186,65810,608951,809993,938230,111558,927386,1024858,535890,1023219,863721,881308,877896,469856,149427,966253,254128,395003,872827,697888,1030093,797321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002019s ]