SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599811 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599811 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544926,1038917,75944,1009358,721896,595821,906963,774976,477725,5466,112159,132189,536696,439346,537074,954013,593013,450711,922565,650503,173076,357464,273358,37748,140105,547354,811911,571016,709297,933238,599742,1030730,389790,186516,950075,701164,455922,202913,745372,842350,658587,1025262,258063,722827,318139,567079,843158,743513,195261,260315,924212,731233,79006,846753,875008,698790,433887,473259,876139,621627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002704s ]