SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431028 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431028 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568050,423649,41470,149809,181910,377916,465605,393323,844631,561503,874149,52281,897067,588031,390949,5408,325347,12082,218201,114693,217360,930854,339169,1019278,729326,590571,112536,634096,315980,465624,691701,578471,766114,1040992,622793,110934,790092,876665,829709,1004565,524437,1032376,199467,956512,47267,985751,260017,600340,410628,649974,437957,482877,1011670,53992,750959,971330,279241,262209,642084,411375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]