SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254040 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254040 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109891,1026640,772970,947840,888081,666466,305263,2755,433262,853973,222499,968675,466320,188913,945562,685941,203345,80526,797956,688818,343320,774083,900340,59656,388429,475914,1008393,622937,331751,609097,974835,727556,384438,1011291,348864,343302,333595,761787,406353,166944,359933,55670,327825,342760,416082,542722,946541,935128,435620,845409,511516,537626,71351,262676,409860,783892,512378,645552,971528,857399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]