SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804876 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804876 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566044,163239,153501,22873,304270,809424,911638,1017189,998338,368778,437001,649797,831087,484763,887296,55093,778218,684463,51323,761014,1012916,2696,543106,113370,94312,51835,1009537,820469,471756,758452,942457,628366,748797,286313,173876,970925,272466,1011349,803574,879095,1015150,350452,768682,595280,393348,627374,92716,705438,281457,62381,692684,471744,377385,590199,700277,1009324,14651,495537,506082,913635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]