SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490752 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490752 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3810,454290,736145,1028252,171286,193473,245544,500888,581302,441241,960431,100457,921994,1045618,918784,522745,861297,927719,703386,428487,78210,925755,183195,605053,872586,841047,98698,225329,951702,502534,1040642,98083,324857,463119,136798,52553,759205,273555,1015119,742670,118358,518925,777827,51183,56663,508365,613360,55248,638656,975089,161008,850740,488553,734505,534486,325711,816835,77642,377037,427596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000887s ]