SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419880 LIMIT 1 [ RunTime:0.002323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419880 [ RunTime:0.004295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965092,454718,913571,1029400,152379,332321,141254,940598,239909,114486,536738,425207,747789,459108,236281,476901,706462,920055,913388,375693,151229,128607,150800,670496,527957,970898,992464,1027837,302328,618557,276182,1029329,377020,156292,951976,84875,170941,171418,741707,372744,556790,271793,792501,870157,701492,288279,822132,320436,509688,137665,456398,322069,672994,363862,562979,537545,917579,69301,439227,1041583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]