SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558972 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558972 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249150,628678,756914,637287,672833,181491,414727,722110,386419,613742,989488,809685,761134,560346,694632,964404,283253,455850,387948,309716,1043567,223202,380174,707399,167327,829316,287399,225634,949501,128016,853686,151828,216655,857750,347584,48042,420628,171259,404342,280000,722292,224042,513330,825163,951907,538584,772867,716606,8417,665737,665947,80598,474244,662116,861660,933424,321666,537858,975935,971991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]