SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101519 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101519 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266765,267638,1019961,852580,576770,622841,183354,466939,194353,419860,574620,278035,194328,703554,400070,798884,668047,727790,250271,719440,569717,154677,616113,690263,326288,18208,201669,215006,750452,878899,1011266,590292,38825,72024,893285,870633,38463,843395,354564,390451,839577,835716,635744,446113,79573,555647,647382,359789,489710,312567,592031,969489,333676,823076,254691,696826,1032379,997504,870473,428700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003772s ]