SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283199 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283199 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80196,659243,1000462,567594,852674,1029069,277933,563692,958090,10205,132385,641013,427487,522230,490496,1037991,43123,230293,297410,126526,928569,871802,123212,5429,701789,461957,585168,170254,291916,775565,149198,472555,215036,439544,8970,627302,742096,46639,366967,678514,284010,49774,370000,786325,941894,387887,673562,822779,589084,1047386,1042449,980573,623055,716371,338433,60335,422676,140542,550731,457188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]