SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041284 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041284 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343150,851869,372223,793311,252472,558554,493659,88838,105827,528093,796237,350124,437782,531255,322209,123403,306441,380094,489430,422323,679195,618370,858390,559026,346029,654276,975181,281230,765526,901827,784117,468600,333612,695903,863961,306646,341128,455111,589916,131855,1019683,894669,604558,69941,591365,193735,689231,815092,907790,861390,663197,128824,398248,417128,659635,374393,317985,196066,994757,694145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]