SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336179 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336179 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738183,656939,438108,499531,219536,65949,241842,341934,86234,306490,342073,325004,756868,619518,638857,412133,393414,303541,217628,532647,1000648,1010421,163600,413703,573124,475017,217847,301068,531621,543357,43798,116701,537653,334060,607480,151821,839423,391536,826970,899876,951328,844738,441016,950273,203043,286763,185736,129420,324333,429803,395567,972985,654563,676702,566037,364941,876325,705864,888692,17414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]