SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414011 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414011 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850579,265255,77942,897816,381125,422933,850406,390605,874120,282880,717446,67581,765475,267370,504435,608812,610973,169954,380683,849040,718943,930027,917920,451519,893310,309537,832796,490241,382191,854847,961394,212632,588544,3875,221728,550368,558450,184466,588668,377030,376948,548637,50681,507772,625275,908307,886782,361150,534856,461321,519588,770217,677713,1032732,42041,164602,998288,465547,866316,62950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]