SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041892 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041892 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581080,711249,333419,1009494,534114,726832,112027,938089,551028,474575,318556,723652,407449,376245,986139,556201,413687,193395,815897,175164,581603,412877,464774,384428,646579,754749,3525,243013,172401,547017,698400,896813,835067,242124,103232,688146,495271,335668,454114,33771,495692,367694,562366,981801,39401,225374,557884,455439,594616,720193,175426,662134,599414,1010945,713749,963271,388160,168243,140551,910272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]